/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : dormitory

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 11/01/2024 18:37:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `buildingId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  PRIMARY KEY (`buildingId`,`userId`),
  KEY `userId` (`userId`),
  CONSTRAINT `admins_ibfk_1` FOREIGN KEY (`buildingId`) REFERENCES `buildings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `admins_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admins
-- ----------------------------
BEGIN;
INSERT INTO `admins` VALUES ('2020-02-22 14:47:30', '2020-02-22 14:47:30', 3, 2);
INSERT INTO `admins` VALUES ('2020-02-22 14:59:08', '2020-02-22 14:59:08', 6, 2);
INSERT INTO `admins` VALUES ('2020-02-24 14:22:51', '2020-02-24 14:22:51', 7, 12);
COMMIT;

-- ----------------------------
-- Table structure for backrecords
-- ----------------------------
DROP TABLE IF EXISTS `backrecords`;
CREATE TABLE `backrecords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `roomId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roomId` (`roomId`),
  CONSTRAINT `backrecords_ibfk_1` FOREIGN KEY (`roomId`) REFERENCES `rooms` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of backrecords
-- ----------------------------
BEGIN;
INSERT INTO `backrecords` VALUES (1, '2020-02-15 17:47:55', '2020-02-15 17:47:55', NULL, 1, 1);
INSERT INTO `backrecords` VALUES (2, '2020-02-17 13:56:02', '2020-02-17 22:56:55', NULL, 1, 1);
INSERT INTO `backrecords` VALUES (3, '2020-02-17 13:56:02', '2020-02-18 19:04:43', NULL, 4, 1);
INSERT INTO `backrecords` VALUES (4, '2020-02-01 13:56:02', '2020-02-17 13:56:02', NULL, 5, 1);
INSERT INTO `backrecords` VALUES (5, '2020-02-02 13:56:02', '2020-02-01 13:56:02', NULL, 5, 1);
INSERT INTO `backrecords` VALUES (6, '2020-02-03 13:56:02', '2020-02-01 13:56:02', NULL, 5, 1);
INSERT INTO `backrecords` VALUES (7, '2020-02-19 12:43:57', '2020-02-19 12:43:57', NULL, 1, 1);
INSERT INTO `backrecords` VALUES (14, '2020-02-21 14:27:53', '2020-02-21 14:27:53', NULL, 6, 2);
INSERT INTO `backrecords` VALUES (15, '2020-02-22 12:31:26', '2020-02-22 12:31:26', NULL, 1, 1);
INSERT INTO `backrecords` VALUES (16, '2020-02-22 14:44:39', '2020-02-22 14:44:39', NULL, 6, 2);
INSERT INTO `backrecords` VALUES (17, '2020-02-24 11:49:19', '2020-02-24 11:49:19', NULL, 5, 1);
INSERT INTO `backrecords` VALUES (18, '2020-02-24 14:08:36', '2020-02-24 14:08:36', NULL, 11, 1);
INSERT INTO `backrecords` VALUES (19, '2020-02-24 14:36:11', '2020-02-24 14:36:11', NULL, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for buildings
-- ----------------------------
DROP TABLE IF EXISTS `buildings`;
CREATE TABLE `buildings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '楼宇名称',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of buildings
-- ----------------------------
BEGIN;
INSERT INTO `buildings` VALUES (1, '通天苑', '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL);
INSERT INTO `buildings` VALUES (2, '大西门', '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL);
INSERT INTO `buildings` VALUES (3, '于心苑', '2020-02-21 11:36:05', '2020-02-21 11:36:07', NULL);
INSERT INTO `buildings` VALUES (6, '测试楼层', '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL);
INSERT INTO `buildings` VALUES (7, '测试楼2', '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL);
COMMIT;

-- ----------------------------
-- Table structure for cleaners
-- ----------------------------
DROP TABLE IF EXISTS `cleaners`;
CREATE TABLE `cleaners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '保洁员姓名',
  `phone` varchar(255) DEFAULT NULL COMMENT '保洁员电话',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `buildingId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `buildingId` (`buildingId`),
  CONSTRAINT `cleaners_ibfk_1` FOREIGN KEY (`buildingId`) REFERENCES `buildings` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cleaners
-- ----------------------------
BEGIN;
INSERT INTO `cleaners` VALUES (1, '凉风阿姨', '13822222222', '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, 1);
INSERT INTO `cleaners` VALUES (2, '巫山阿姨', '12233333333', '2020-02-22 11:09:56', '2020-02-22 11:09:56', NULL, 1);
INSERT INTO `cleaners` VALUES (3, '宿舍阿姨', '12345678901', '2020-02-22 12:29:49', '2020-02-22 12:29:49', '2020-02-23 10:09:39', 1);
INSERT INTO `cleaners` VALUES (4, '贝贝阿姨', '123455666666', '2020-02-22 12:34:11', '2020-02-22 12:34:11', NULL, 2);
INSERT INTO `cleaners` VALUES (5, '测试阿姨', '12333333333', '2020-02-22 16:11:30', '2020-02-22 16:11:30', NULL, 6);
INSERT INTO `cleaners` VALUES (6, '测试保洁员', '12333333333', '2020-02-24 14:23:47', '2020-02-24 14:23:47', NULL, 7);
COMMIT;

-- ----------------------------
-- Table structure for cleanrecords
-- ----------------------------
DROP TABLE IF EXISTS `cleanrecords`;
CREATE TABLE `cleanrecords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `roomId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roomId` (`roomId`),
  CONSTRAINT `cleanrecords_ibfk_1` FOREIGN KEY (`roomId`) REFERENCES `rooms` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cleanrecords
-- ----------------------------
BEGIN;
INSERT INTO `cleanrecords` VALUES (1, '2020-02-12 21:46:16', '2020-02-19 21:46:22', NULL, 1, 1);
INSERT INTO `cleanrecords` VALUES (2, '2020-02-16 12:22:36', '2020-02-19 21:46:39', NULL, 1, 1);
INSERT INTO `cleanrecords` VALUES (3, '2020-02-19 14:12:22', '2020-02-19 22:12:54', NULL, 4, 1);
INSERT INTO `cleanrecords` VALUES (5, '2020-02-20 07:00:37', '2020-02-20 07:00:37', NULL, 1, 1);
INSERT INTO `cleanrecords` VALUES (6, '2020-02-21 08:56:01', '2020-02-21 08:56:01', NULL, 6, 2);
INSERT INTO `cleanrecords` VALUES (7, '2020-02-21 10:20:59', '2020-02-21 10:20:59', NULL, 1, 1);
INSERT INTO `cleanrecords` VALUES (8, '2020-02-21 17:26:48', '2020-02-21 17:26:48', NULL, 1, 1);
INSERT INTO `cleanrecords` VALUES (9, '2020-02-22 14:44:43', '2020-02-22 14:44:43', NULL, 6, 2);
INSERT INTO `cleanrecords` VALUES (10, '2020-02-24 11:49:17', '2020-02-24 11:49:17', NULL, 5, 1);
COMMIT;

-- ----------------------------
-- Table structure for evaluates
-- ----------------------------
DROP TABLE IF EXISTS `evaluates`;
CREATE TABLE `evaluates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `score` int(11) NOT NULL COMMENT '评价分数',
  `note` varchar(255) DEFAULT NULL COMMENT '评价备注',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `roomId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roomId` (`roomId`),
  CONSTRAINT `evaluates_ibfk_1` FOREIGN KEY (`roomId`) REFERENCES `rooms` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of evaluates
-- ----------------------------
BEGIN;
INSERT INTO `evaluates` VALUES (1, 98, '宿舍不错', '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, 2, 1);
INSERT INTO `evaluates` VALUES (2, 75, '一般般吧', '2020-02-13 21:20:13', '2020-02-13 21:20:25', NULL, 2, 1);
INSERT INTO `evaluates` VALUES (3, 59, '很差劲', '2020-02-01 21:20:42', '2020-02-01 21:20:46', NULL, 2, 1);
INSERT INTO `evaluates` VALUES (5, 60, '一般一般', '2020-02-24 13:50:59', '2020-02-24 14:14:19', '2020-02-24 14:14:19', 2, 1);
INSERT INTO `evaluates` VALUES (6, 100, '不错i', '2020-02-24 13:51:55', '2020-02-24 14:01:27', '2020-02-24 14:01:27', 2, 1);
INSERT INTO `evaluates` VALUES (7, 60, '评价测试', '2020-02-24 14:14:38', '2020-02-24 14:14:38', NULL, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for floors
-- ----------------------------
DROP TABLE IF EXISTS `floors`;
CREATE TABLE `floors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layer` int(11) DEFAULT NULL COMMENT '楼层',
  `buildingId` int(11) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `cleanerId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `compositeIndex` (`layer`,`buildingId`),
  KEY `buildingId` (`buildingId`),
  KEY `cleanerId` (`cleanerId`),
  CONSTRAINT `floors_ibfk_1` FOREIGN KEY (`buildingId`) REFERENCES `buildings` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `floors_ibfk_2` FOREIGN KEY (`cleanerId`) REFERENCES `cleaners` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of floors
-- ----------------------------
BEGIN;
INSERT INTO `floors` VALUES (1, 1, 1, '2020-02-15 14:34:55', '2020-02-24 14:12:32', NULL, 1);
INSERT INTO `floors` VALUES (2, 2, 1, '2020-02-15 14:34:55', '2020-02-24 14:12:37', NULL, NULL);
INSERT INTO `floors` VALUES (3, 3, 1, '2020-02-15 14:34:55', '2020-02-23 10:09:51', NULL, 1);
INSERT INTO `floors` VALUES (4, 4, 1, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `floors` VALUES (5, 5, 1, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `floors` VALUES (6, 6, 1, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `floors` VALUES (7, 7, 1, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `floors` VALUES (8, 8, 1, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `floors` VALUES (9, 9, 1, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `floors` VALUES (10, 10, 1, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `floors` VALUES (11, 1, 3, '2020-02-21 11:36:29', '2020-02-21 11:36:31', NULL, NULL);
INSERT INTO `floors` VALUES (14, 1, 6, '2020-02-22 14:58:45', '2020-02-22 16:11:39', NULL, 5);
INSERT INTO `floors` VALUES (15, 2, 6, '2020-02-22 14:58:45', '2020-02-24 14:12:21', NULL, 5);
INSERT INTO `floors` VALUES (16, 3, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, NULL);
INSERT INTO `floors` VALUES (17, 4, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, NULL);
INSERT INTO `floors` VALUES (18, 5, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, NULL);
INSERT INTO `floors` VALUES (19, 6, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, NULL);
INSERT INTO `floors` VALUES (20, 7, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, NULL);
INSERT INTO `floors` VALUES (21, 8, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, NULL);
INSERT INTO `floors` VALUES (22, 9, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, NULL);
INSERT INTO `floors` VALUES (23, 1, 7, '2020-02-24 14:22:24', '2020-02-24 14:24:13', NULL, 6);
INSERT INTO `floors` VALUES (24, 2, 7, '2020-02-24 14:22:25', '2020-02-24 14:24:19', NULL, 6);
INSERT INTO `floors` VALUES (25, 3, 7, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for getuprecords
-- ----------------------------
DROP TABLE IF EXISTS `getuprecords`;
CREATE TABLE `getuprecords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `roomId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `roomId` (`roomId`),
  CONSTRAINT `getuprecords_ibfk_1` FOREIGN KEY (`roomId`) REFERENCES `rooms` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of getuprecords
-- ----------------------------
BEGIN;
INSERT INTO `getuprecords` VALUES (8, '2020-02-15 12:11:17', '2020-02-15 12:11:17', NULL, 4, 1);
INSERT INTO `getuprecords` VALUES (9, '2020-02-16 12:12:00', '2020-02-16 12:12:00', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (13, '2020-02-16 17:16:14', '2020-02-16 17:16:14', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (14, '2020-02-01 21:24:26', '2020-02-01 21:24:31', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (16, '2020-02-18 11:06:43', '2020-02-18 11:06:43', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (17, '2020-02-19 12:41:58', '2020-02-19 12:41:58', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (27, '2020-02-21 14:25:18', '2020-02-21 14:25:18', NULL, 6, 2);
INSERT INTO `getuprecords` VALUES (28, '2020-02-22 12:31:23', '2020-02-22 12:31:23', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (29, '2020-02-22 14:44:37', '2020-02-22 14:44:37', NULL, 6, 2);
INSERT INTO `getuprecords` VALUES (30, '2020-02-24 11:49:22', '2020-02-24 11:49:22', NULL, 5, 1);
INSERT INTO `getuprecords` VALUES (31, '2020-01-09 19:51:21', '2020-02-06 19:51:28', NULL, 4, 1);
INSERT INTO `getuprecords` VALUES (32, '2020-01-17 19:51:43', '2020-02-24 19:51:50', NULL, 5, 1);
INSERT INTO `getuprecords` VALUES (33, '2020-01-24 19:52:03', '2020-02-24 19:52:08', NULL, 5, 1);
INSERT INTO `getuprecords` VALUES (34, '2020-01-17 19:52:18', '2020-02-24 19:52:23', NULL, 5, 1);
INSERT INTO `getuprecords` VALUES (35, '2020-01-17 19:52:30', '2020-02-05 19:52:34', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (36, '2020-01-18 19:52:43', '2020-02-24 19:52:49', NULL, 1, 1);
INSERT INTO `getuprecords` VALUES (37, '2020-02-24 14:08:05', '2020-02-24 14:08:05', NULL, 11, 1);
COMMIT;

-- ----------------------------
-- Table structure for rooms
-- ----------------------------
DROP TABLE IF EXISTS `rooms`;
CREATE TABLE `rooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` int(11) DEFAULT NULL COMMENT '房间号',
  `buildingId` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '宿舍状态，可入住为1，不可入住为2',
  `peopleNum` int(11) NOT NULL COMMENT '房间最大人数',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `floorId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `compositeIndex` (`number`,`buildingId`),
  KEY `buildingId` (`buildingId`),
  KEY `floorId` (`floorId`),
  CONSTRAINT `rooms_ibfk_1` FOREIGN KEY (`buildingId`) REFERENCES `buildings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `rooms_ibfk_2` FOREIGN KEY (`floorId`) REFERENCES `floors` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rooms
-- ----------------------------
BEGIN;
INSERT INTO `rooms` VALUES (1, 101, 1, 1, 6, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, 1);
INSERT INTO `rooms` VALUES (2, 101, 3, 1, 6, '2020-02-21 11:37:11', '2020-02-21 11:37:14', NULL, 11);
INSERT INTO `rooms` VALUES (5, 101, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (6, 102, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (7, 103, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (8, 104, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (9, 105, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (10, 106, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (11, 107, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (12, 108, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (13, 109, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (14, 110, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (15, 111, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (16, 112, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (17, 113, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (18, 114, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (19, 115, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (20, 116, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (21, 117, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (22, 118, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (23, 119, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (24, 120, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 14);
INSERT INTO `rooms` VALUES (25, 201, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (26, 202, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (27, 203, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (28, 204, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (29, 205, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (30, 206, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (31, 207, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (32, 208, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (33, 209, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (34, 210, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (35, 211, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (36, 212, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (37, 213, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (38, 214, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (39, 215, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (40, 216, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (41, 217, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (42, 218, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (43, 219, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (44, 220, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 15);
INSERT INTO `rooms` VALUES (45, 301, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (46, 302, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (47, 303, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (48, 304, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (49, 305, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (50, 306, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (51, 307, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (52, 308, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (53, 309, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (54, 310, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (55, 311, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (56, 312, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (57, 313, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (58, 314, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (59, 315, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (60, 316, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (61, 317, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (62, 318, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (63, 319, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (64, 320, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 16);
INSERT INTO `rooms` VALUES (65, 401, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (66, 402, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (67, 403, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (68, 404, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (69, 405, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (70, 406, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (71, 407, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (72, 408, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (73, 409, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (74, 410, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (75, 411, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (76, 412, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (77, 413, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (78, 414, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (79, 415, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (80, 416, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (81, 417, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (82, 418, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (83, 419, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (84, 420, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 17);
INSERT INTO `rooms` VALUES (85, 501, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 18);
INSERT INTO `rooms` VALUES (86, 502, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 18);
INSERT INTO `rooms` VALUES (87, 503, 6, 1, 6, '2020-02-22 14:58:45', '2020-02-22 14:58:45', NULL, 18);
INSERT INTO `rooms` VALUES (88, 504, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (89, 505, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (90, 506, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (91, 507, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (92, 508, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (93, 509, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (94, 510, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (95, 511, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (96, 512, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (97, 513, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (98, 514, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (99, 515, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (100, 516, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (101, 517, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (102, 518, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (103, 519, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (104, 520, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 18);
INSERT INTO `rooms` VALUES (105, 601, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (106, 602, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (107, 603, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (108, 604, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (109, 605, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (110, 606, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (111, 607, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (112, 608, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (113, 609, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (114, 610, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (115, 611, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (116, 612, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (117, 613, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (118, 614, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (119, 615, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (120, 616, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (121, 617, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (122, 618, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (123, 619, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (124, 620, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 19);
INSERT INTO `rooms` VALUES (125, 701, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (126, 702, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (127, 703, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (128, 704, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (129, 705, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (130, 706, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (131, 707, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (132, 708, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (133, 709, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (134, 710, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (135, 711, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (136, 712, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (137, 713, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (138, 714, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (139, 715, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (140, 716, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (141, 717, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (142, 718, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (143, 719, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (144, 720, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 20);
INSERT INTO `rooms` VALUES (145, 801, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (146, 802, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (147, 803, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (148, 804, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (149, 805, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (150, 806, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (151, 807, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (152, 808, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (153, 809, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (154, 810, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (155, 811, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (156, 812, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (157, 813, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (158, 814, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (159, 815, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (160, 816, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (161, 817, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (162, 818, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (163, 819, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (164, 820, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 21);
INSERT INTO `rooms` VALUES (165, 901, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (166, 902, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (167, 903, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (168, 904, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (169, 905, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (170, 906, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (171, 907, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (172, 908, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (173, 909, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (174, 910, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (175, 911, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (176, 912, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (177, 913, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (178, 914, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (179, 915, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (180, 916, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (181, 917, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (182, 918, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (183, 919, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (184, 920, 6, 1, 6, '2020-02-22 14:58:46', '2020-02-22 14:58:46', NULL, 22);
INSERT INTO `rooms` VALUES (185, 101, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (186, 102, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (187, 103, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (188, 104, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (189, 105, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (190, 106, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (191, 107, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (192, 108, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (193, 109, 7, 1, 6, '2020-02-24 14:22:24', '2020-02-24 14:22:24', NULL, 23);
INSERT INTO `rooms` VALUES (194, 110, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 23);
INSERT INTO `rooms` VALUES (195, 201, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (196, 202, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (197, 203, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (198, 204, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (199, 205, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (200, 206, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (201, 207, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (202, 208, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (203, 209, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (204, 210, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 24);
INSERT INTO `rooms` VALUES (205, 301, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (206, 302, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (207, 303, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (208, 304, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (209, 305, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (210, 306, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (211, 307, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (212, 308, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (213, 309, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
INSERT INTO `rooms` VALUES (214, 310, 7, 1, 6, '2020-02-24 14:22:25', '2020-02-24 14:22:25', NULL, 25);
COMMIT;

-- ----------------------------
-- Table structure for sp_customer
-- ----------------------------
DROP TABLE IF EXISTS `sp_customer`;
CREATE TABLE `sp_customer` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增序号',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `company_name` varchar(100) NOT NULL DEFAULT '' COMMENT '单位名称',
  `full_company_name` varchar(100) NOT NULL DEFAULT '' COMMENT '单位名称—简称',
  `customer_name` varchar(100) NOT NULL DEFAULT '' COMMENT '联系人',
  `phone` varchar(255) NOT NULL DEFAULT '' COMMENT '移动电话',
  `tel_phone` varchar(255) NOT NULL DEFAULT '' COMMENT '固定电话',
  `area` varchar(255) NOT NULL DEFAULT '' COMMENT '区域： 取字典值 customer_area',
  `area_address` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `company_type` varchar(100) NOT NULL DEFAULT '' COMMENT '企业类型：取字典值 company_type',
  `customer_type` varchar(100) NOT NULL DEFAULT '' COMMENT '供销类型： 1: 供应商，2: 经销商，3: 供销皆是',
  `bank_name` varchar(100) NOT NULL DEFAULT '' COMMENT '开户行',
  `bank` varchar(100) NOT NULL DEFAULT '' COMMENT '银行帐号',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态：1: 正常 2: 一般',
  `remarks` text COMMENT '备注',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_delete` int(2) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `config` varchar(1000) DEFAULT NULL COMMENT '其他数据',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `customer_name` (`customer_name`,`store_id`) USING BTREE,
  UNIQUE KEY `sub_company_name` (`full_company_name`,`store_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='客户表';

-- ----------------------------
-- Records of sp_customer
-- ----------------------------
BEGIN;
INSERT INTO `sp_customer` VALUES (1, 5, '客户单位1', '客户单位1', '客户1', '', '', '广东省 广州市', '', '2', '3', '', '', 1, '', '2023-02-27 19:37:25', '2023-02-27 19:37:25', 0, NULL);
INSERT INTO `sp_customer` VALUES (2, 5, '单位2', '单位2', '陈总', '13899900020', '', '天津市 天津市', '阿斯顿阿斯顿123', '1', '3', '', '', 1, '', '2023-06-01 22:34:13', '2023-09-03 23:17:02', 0, NULL);
INSERT INTO `sp_customer` VALUES (3, 5, '供应商1', '供应商1', '陈', '', '', '广东省 广州市', '123', '', '1', '', '', 1, '', '2023-08-06 14:04:06', '2023-09-03 23:17:11', 0, NULL);
INSERT INTO `sp_customer` VALUES (4, 5, '销售商1', '销售商1', '', '', '', '广东省 广州市', '', '', '2', '', '', 1, '', '2023-08-07 15:48:07', '2023-08-07 15:48:07', 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sp_goods
-- ----------------------------
DROP TABLE IF EXISTS `sp_goods`;
CREATE TABLE `sp_goods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增序号',
  `goods_name` varchar(100) NOT NULL DEFAULT '' COMMENT '商品名称',
  `full_goods_name` varchar(100) NOT NULL DEFAULT '' COMMENT '商品名称—简称',
  `cat_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '分类ID',
  `attr` varchar(100) NOT NULL DEFAULT '' COMMENT '属性',
  `stock` bigint(20) NOT NULL DEFAULT '0' COMMENT '库存',
  `sales` bigint(20) NOT NULL DEFAULT '0' COMMENT '销量',
  `weight` bigint(20) NOT NULL DEFAULT '0' COMMENT '商品重量',
  `desc` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `sort` bigint(20) NOT NULL DEFAULT '500' COMMENT '排序',
  `store_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '门店id, 0系统商品',
  `is_hot` int(2) NOT NULL DEFAULT '0' COMMENT '是否热销： 0否，1是',
  `is_recommend` int(2) NOT NULL DEFAULT '0' COMMENT '是否推荐： 0否，1是',
  `status` bigint(20) NOT NULL DEFAULT '0' COMMENT '状态 0未上架1上架2已下架',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` int(2) NOT NULL DEFAULT '0' COMMENT '是否删除： 0否，1是',
  `image` varchar(256) NOT NULL DEFAULT '' COMMENT '图片',
  `slider_image` varchar(2000) NOT NULL DEFAULT '' COMMENT '轮播图',
  `content` text COMMENT '详情 富文本',
  `unit_name` varchar(10) DEFAULT NULL COMMENT '基本单位',
  `unit_name2` varchar(10) DEFAULT NULL COMMENT '辅助单位',
  `unit_convert` int(10) DEFAULT NULL COMMENT '基本单位换算',
  `unit_convert2` int(11) DEFAULT NULL COMMENT '辅助单位换算',
  `is_delete` int(2) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `goods_type` int(11) NOT NULL DEFAULT '1' COMMENT '商品类型：1: 普通商品，2: 虚拟商品(如：运费)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`goods_name`,`store_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='商品列表';

-- ----------------------------
-- Records of sp_goods
-- ----------------------------
BEGIN;
INSERT INTO `sp_goods` VALUES (6, '捷时达995', '捷时达995硅酮结构密封胶', 77, '', 12180, 0, 0, '', 500, 5, 0, 0, 1, '2023-08-03 22:45:10', '2023-09-09 18:38:59', 0, '', '', NULL, '支', '件', 1, 20, 0, 1);
INSERT INTO `sp_goods` VALUES (15, '捷时达666', '捷时达666硅酮结构密封胶', 77, '', 0, 0, 0, '', 500, 5, 0, 0, 1, '2023-08-16 16:59:59', '2023-08-23 14:44:48', 0, '', '', NULL, '支', '件', 1, 20, 0, 1);
INSERT INTO `sp_goods` VALUES (19, '荣御929', '荣御929硅酮结构密封胶', 77, '', 0, 0, 0, '', 500, 5, 0, 0, 1, '2023-08-23 14:54:54', '2023-08-23 14:54:54', 0, '', '', NULL, '支', '件', 1, 20, 0, 1);
INSERT INTO `sp_goods` VALUES (21, '小双柱胶枪', '小双柱胶枪', 80, '', 0, 0, 0, '', 500, 5, 0, 0, 1, '2023-09-11 22:03:37', '2023-09-11 22:03:37', 0, '', '', NULL, '支', '件', 1, 30, 0, 1);
INSERT INTO `sp_goods` VALUES (22, '荣御995', '荣御995硅酮结构密封胶', 77, '', 0, 0, 0, '', 500, 5, 0, 0, 1, '2023-11-07 16:51:17', '2023-11-07 16:51:17', 0, '', '', NULL, '支', '件', 1, 20, 0, 1);
INSERT INTO `sp_goods` VALUES (23, '荣御793', '荣御793密封胶', 77, '', 0, 0, 0, '', 500, 5, 0, 0, 1, '2023-11-07 16:55:31', '2023-11-07 16:55:31', 0, '', '', NULL, '瓶', '件', 1, 24, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sp_goods_attr
-- ----------------------------
DROP TABLE IF EXISTS `sp_goods_attr`;
CREATE TABLE `sp_goods_attr` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增序号',
  `goods_id` bigint(20) NOT NULL COMMENT '商品id',
  `store_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '门店id, 0系统规格',
  `attr_name` varchar(32) NOT NULL DEFAULT '' COMMENT '属性名',
  `attr_values` varchar(256) NOT NULL DEFAULT '' COMMENT '属性值',
  `is_delete` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0: 显示，1: 删除',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`,`goods_id`) USING BTREE,
  UNIQUE KEY `store_id` (`store_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商品属性表';

-- ----------------------------
-- Table structure for sp_goods_cate
-- ----------------------------
DROP TABLE IF EXISTS `sp_goods_cate`;
CREATE TABLE `sp_goods_cate` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `cat_name` varchar(50) NOT NULL COMMENT '分类名称',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父级id',
  `store_id` int(20) DEFAULT NULL COMMENT '门店id',
  `is_show` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示',
  `sort` int(11) NOT NULL DEFAULT '500' COMMENT '排序',
  `data_flag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '数据标记',
  `is_new` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0:旧数据  1:新数据',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`cat_id`),
  UNIQUE KEY `cat_name` (`cat_name`,`store_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='商品分类';

-- ----------------------------
-- Records of sp_goods_cate
-- ----------------------------
BEGIN;
INSERT INTO `sp_goods_cate` VALUES (77, '玻璃胶', 0, 5, 1, 499, 1, '0', '2023-02-27 14:56:13', '2023-08-26 17:26:00');
INSERT INTO `sp_goods_cate` VALUES (78, '发泡胶', 0, 5, 1, 500, 1, '0', '2023-02-27 14:56:29', '2023-02-27 14:56:29');
INSERT INTO `sp_goods_cate` VALUES (79, '免钉胶', 0, 5, 1, 500, 1, '0', '2023-02-27 14:57:17', '2023-02-27 14:57:17');
INSERT INTO `sp_goods_cate` VALUES (80, '其他', 0, 5, 1, 500, 1, '0', '2023-02-28 14:57:21', '2023-02-28 15:57:21');
INSERT INTO `sp_goods_cate` VALUES (81, '玻璃胶', 0, 7, 1, 500, 1, '0', '2023-06-01 20:57:14', '2023-06-01 20:57:14');
INSERT INTO `sp_goods_cate` VALUES (82, '发泡胶', 0, 7, 1, 500, 1, '0', '2023-06-01 20:57:24', '2023-06-01 20:57:24');
INSERT INTO `sp_goods_cate` VALUES (83, '其他', 0, 7, 1, 500, 1, '0', '2023-06-01 20:57:54', '2023-06-01 20:57:54');
INSERT INTO `sp_goods_cate` VALUES (86, '玻璃胶21', 0, 5, 1, 500, 1, '0', '2023-08-26 17:32:50', '2023-08-26 17:40:47');
INSERT INTO `sp_goods_cate` VALUES (87, '玻璃胶13', 0, 5, 1, 500, 1, '0', '2023-08-26 17:33:50', '2023-08-26 17:38:55');
INSERT INTO `sp_goods_cate` VALUES (88, '玻璃胶33', 0, 5, 1, 500, 1, '0', '2023-08-26 17:36:15', '2023-08-26 17:40:32');
COMMIT;

-- ----------------------------
-- Table structure for sp_store
-- ----------------------------
DROP TABLE IF EXISTS `sp_store`;
CREATE TABLE `sp_store` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '门店id',
  `store_no` varchar(200) NOT NULL DEFAULT '' COMMENT '编号，0001',
  `store_type` int(11) NOT NULL DEFAULT '0' COMMENT '门店类型 0自营，加盟',
  `store_name` varchar(200) NOT NULL DEFAULT '' COMMENT '门店名称',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `area` varchar(200) NOT NULL DEFAULT '' COMMENT '区域，eg: 广州，东莞',
  `area_address` varchar(1000) NOT NULL DEFAULT '' COMMENT '详情地址',
  `is_show` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `config` varchar(2000) DEFAULT NULL COMMENT '其他配置',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='门店表';

-- ----------------------------
-- Records of sp_store
-- ----------------------------
BEGIN;
INSERT INTO `sp_store` VALUES (5, '001', 0, '广州荣御胶粘', '', '广州', '广州天健广场', 1, '2023-02-26 19:55:32', '2023-09-10 17:18:36', '[{\"label\":\"库存负载\",\"key\":\"isAllowLoad\",\"value\":true},{\"label\":\"库存警告\",\"key\":\"isStockCordon\",\"value\":true}]');
INSERT INTO `sp_store` VALUES (6, '002', 0, '东莞荣御胶业', '', '东莞', '东莞寮步', 1, '2023-02-26 19:57:14', '2023-02-26 19:57:14', '{\"isAllowLoad\":false}');
COMMIT;

-- ----------------------------
-- Table structure for sp_store_goods_attr_config
-- ----------------------------
DROP TABLE IF EXISTS `sp_store_goods_attr_config`;
CREATE TABLE `sp_store_goods_attr_config` (
  `goods_id` bigint(11) unsigned NOT NULL COMMENT '商品ID',
  `config` longtext NOT NULL COMMENT '商品属性参数',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`goods_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='商品规格配置表';

-- ----------------------------
-- Records of sp_store_goods_attr_config
-- ----------------------------
BEGIN;
INSERT INTO `sp_store_goods_attr_config` VALUES (6, '[{\"sku\":\"透明\",\"price\":\"10\",\"cost_price\":\"9\",\"stock\":\"102\",\"weight\":590,\"goods_name\":\"捷时达995\"},{\"sku\":\"黑色\",\"price\":\"9\",\"cost_price\":\"8\",\"stock\":100,\"weight\":590,\"goods_name\":\"捷时达995\"},{\"sku\":\"白色\",\"price\":\"9\",\"cost_price\":\"8\",\"stock\":100,\"weight\":590,\"goods_name\":\"捷时达995\"},{\"sku\":\"灰色\",\"price\":\"9\",\"cost_price\":\"8\",\"stock\":100,\"weight\":590,\"goods_name\":\"捷时达995\"}]', '2023-08-03 22:45:10', '2023-08-03 22:45:10');
INSERT INTO `sp_store_goods_attr_config` VALUES (7, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:39:53', '2023-08-16 16:39:53');
INSERT INTO `sp_store_goods_attr_config` VALUES (8, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:50:54', '2023-08-16 16:50:54');
INSERT INTO `sp_store_goods_attr_config` VALUES (9, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:51:51', '2023-08-16 16:51:51');
INSERT INTO `sp_store_goods_attr_config` VALUES (10, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:52:23', '2023-08-16 16:52:23');
INSERT INTO `sp_store_goods_attr_config` VALUES (11, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:53:52', '2023-08-16 16:53:52');
INSERT INTO `sp_store_goods_attr_config` VALUES (12, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:54:31', '2023-08-16 16:54:31');
INSERT INTO `sp_store_goods_attr_config` VALUES (13, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:56:24', '2023-08-16 16:56:24');
INSERT INTO `sp_store_goods_attr_config` VALUES (14, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:58:32', '2023-08-16 16:58:32');
INSERT INTO `sp_store_goods_attr_config` VALUES (15, '[{\"sku\":\"透明\",\"price\":\"8\",\"cost_price\":\"6\",\"stock\":\"200\",\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"黑色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"白色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"},{\"sku\":\"灰色\",\"price\":\"7\",\"cost_price\":\"6\",\"stock\":100,\"weight\":0,\"goods_name\":\"捷时达666\"}]', '2023-08-16 16:59:59', '2023-08-16 16:59:59');
INSERT INTO `sp_store_goods_attr_config` VALUES (16, '[{\"sku\":\"透明\",\"price\":\"12\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"黑色\",\"price\":\"11\",\"cost_price\":\"9\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"白色\",\"price\":\"11\",\"cost_price\":\"9\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"灰色\",\"price\":\"11\",\"cost_price\":\"9\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"}]', '2023-08-23 14:49:10', '2023-08-23 14:49:10');
INSERT INTO `sp_store_goods_attr_config` VALUES (17, '[{\"sku\":\"透明\",\"price\":\"12\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"黑色\",\"price\":\"11\",\"cost_price\":\"9\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"白色\",\"price\":\"11\",\"cost_price\":\"9\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"灰色\",\"price\":\"11\",\"cost_price\":\"9\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"}]', '2023-08-23 14:50:53', '2023-08-23 14:50:53');
INSERT INTO `sp_store_goods_attr_config` VALUES (18, '[{\"sku\":\"透明\",\"price\":\"12\",\"cost_price\":\"11\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"黑色\",\"price\":\"11\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"白色\",\"price\":\"11\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"},{\"sku\":\"灰色\",\"price\":\"11\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929硅酮结构密封胶\"}]', '2023-08-23 14:52:14', '2023-08-23 14:52:14');
INSERT INTO `sp_store_goods_attr_config` VALUES (19, '[{\"sku\":\"透明\",\"price\":\"12\",\"cost_price\":\"11\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929\"},{\"sku\":\"黑色\",\"price\":\"11\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929\"},{\"sku\":\"白色\",\"price\":\"11\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929\"},{\"sku\":\"灰色\",\"price\":\"11\",\"cost_price\":\"10\",\"stock\":100,\"weight\":0,\"goods_name\":\"荣御929\"}]', '2023-08-23 14:54:54', '2023-08-23 14:54:54');
INSERT INTO `sp_store_goods_attr_config` VALUES (20, '[{\"goods_id\":20,\"sku\":\"默认\",\"store_id\":\"5\",\"store_house_id\":\"\",\"stock\":0,\"sales\":0,\"price\":0,\"cost_price\":0,\"image\":\"\",\"weight\":0,\"volume\":0,\"sort\":500}]', '2023-09-09 18:12:52', '2023-09-09 18:12:52');
INSERT INTO `sp_store_goods_attr_config` VALUES (21, '[{\"sku\":\"默认\",\"price\":\"5\",\"cost_price\":\"4\",\"cordon\":\"30\",\"goods_name\":\"小双柱胶枪\"}]', '2023-09-11 22:03:37', '2023-09-11 22:03:37');
COMMIT;

-- ----------------------------
-- Table structure for sp_store_goods_attr_value
-- ----------------------------
DROP TABLE IF EXISTS `sp_store_goods_attr_value`;
CREATE TABLE `sp_store_goods_attr_value` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商品规格id',
  `goods_id` bigint(10) unsigned NOT NULL COMMENT '商品ID',
  `goods_name` varchar(100) DEFAULT NULL COMMENT '商品名称',
  `sku` varchar(128) NOT NULL COMMENT '商品属性索引值 (attr_value|attr_value[|....])',
  `stock` int(10) unsigned NOT NULL COMMENT '属性对应的库存',
  `cordon` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '库存警戒线',
  `store_house_id` varchar(200) NOT NULL DEFAULT '' COMMENT '仓库id',
  `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量',
  `price` decimal(8,2) unsigned NOT NULL COMMENT '属性金额',
  `cost_price` decimal(8,2) NOT NULL COMMENT '成本价',
  `image` varchar(128) DEFAULT '' COMMENT '图片',
  `weight` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '重量',
  `volume` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '体积',
  `sort` int(20) NOT NULL DEFAULT '500' COMMENT '排序',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`,`goods_id`,`sku`) USING BTREE,
  UNIQUE KEY `goods_id` (`goods_id`,`sku`) USING BTREE,
  CONSTRAINT `sp_store_goods_attr_value_ibfk_1` FOREIGN KEY (`goods_id`) REFERENCES `sp_goods` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='商品属性值表';

-- ----------------------------
-- Records of sp_store_goods_attr_value
-- ----------------------------
BEGIN;
INSERT INTO `sp_store_goods_attr_value` VALUES (1, 6, '捷时达995', '灰色', 0, 0, '1', 0, 9.00, 8.00, '', 590.00, 0.00, 500, '2023-08-03 22:45:10');
INSERT INTO `sp_store_goods_attr_value` VALUES (2, 6, '捷时达995', '白色', 100, 0, '1', 0, 9.00, 8.00, '', 590.00, 0.00, 500, '2023-08-03 22:45:10');
INSERT INTO `sp_store_goods_attr_value` VALUES (3, 6, '捷时达995', '透明', 102, 0, '1', 0, 10.00, 9.00, '', 590.00, 0.00, 500, '2023-08-03 22:45:10');
INSERT INTO `sp_store_goods_attr_value` VALUES (4, 6, '捷时达995', '黑色', 100, 0, '1', 0, 9.00, 8.00, '', 590.00, 0.00, 500, '2023-08-03 22:45:10');
INSERT INTO `sp_store_goods_attr_value` VALUES (55, 15, '捷时达666', '透明', 200, 0, '', 0, 8.00, 6.00, '', 0.00, 0.00, 500, '2023-08-16 16:59:59');
INSERT INTO `sp_store_goods_attr_value` VALUES (56, 15, '捷时达666', '黑色', 100, 0, '', 0, 7.00, 6.00, '', 0.00, 0.00, 500, '2023-08-16 16:59:59');
INSERT INTO `sp_store_goods_attr_value` VALUES (57, 15, '捷时达666', '白色', 100, 0, '', 0, 7.00, 6.00, '', 0.00, 0.00, 500, '2023-08-16 16:59:59');
INSERT INTO `sp_store_goods_attr_value` VALUES (58, 15, '捷时达666', '灰色', 100, 0, '', 0, 7.00, 6.00, '', 0.00, 0.00, 500, '2023-08-16 16:59:59');
INSERT INTO `sp_store_goods_attr_value` VALUES (71, 19, '荣御929', '透明', 100, 0, '', 0, 12.00, 11.00, '', 0.00, 0.00, 500, '2023-08-23 14:54:54');
INSERT INTO `sp_store_goods_attr_value` VALUES (72, 19, '荣御929', '黑色', 100, 0, '', 0, 11.00, 10.00, '', 0.00, 0.00, 500, '2023-08-23 14:54:54');
INSERT INTO `sp_store_goods_attr_value` VALUES (73, 19, '荣御929', '白色', 100, 0, '', 0, 11.00, 10.00, '', 0.00, 0.00, 500, '2023-08-23 14:54:54');
INSERT INTO `sp_store_goods_attr_value` VALUES (74, 19, '荣御929', '灰色', 100, 0, '', 0, 11.00, 10.00, '', 0.00, 0.00, 500, '2023-08-23 14:54:54');
INSERT INTO `sp_store_goods_attr_value` VALUES (75, 6, '捷时达995', '深灰', 0, 100, '', 0, 9.00, 8.00, '', 0.00, 0.00, 500, '2023-09-09 23:11:06');
INSERT INTO `sp_store_goods_attr_value` VALUES (76, 21, '小双柱胶枪', '默认', 0, 30, '', 0, 5.00, 4.00, '', 0.00, 0.00, 500, '2023-09-11 22:12:39');
INSERT INTO `sp_store_goods_attr_value` VALUES (77, 22, '荣御995', '黑色', 0, 200, '', 0, 16.00, 10.00, '', 0.00, 0.00, 500, '2023-11-07 16:51:17');
INSERT INTO `sp_store_goods_attr_value` VALUES (78, 22, '荣御995', '白色', 0, 0, '', 0, 16.00, 10.00, '', 0.00, 0.00, 500, '2023-11-07 16:54:29');
INSERT INTO `sp_store_goods_attr_value` VALUES (79, 23, '荣御793', '白色', 20, 240, '', 0, 7.00, 6.00, '', 0.00, 0.00, 500, '2023-11-07 19:58:32');
COMMIT;

-- ----------------------------
-- Table structure for sp_store_goods_stock
-- ----------------------------
DROP TABLE IF EXISTS `sp_store_goods_stock`;
CREATE TABLE `sp_store_goods_stock` (
  `sku_id` bigint(11) NOT NULL COMMENT '规格id',
  `store_house_id` bigint(11) NOT NULL COMMENT '仓库id',
  `stock` bigint(20) DEFAULT NULL COMMENT '库存',
  `cost_price` decimal(8,0) DEFAULT NULL COMMENT '成本价',
  `price` decimal(8,0) DEFAULT NULL COMMENT '最近价格',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`sku_id`,`store_house_id`) USING BTREE,
  UNIQUE KEY `sku_id` (`sku_id`,`store_house_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of sp_store_goods_stock
-- ----------------------------
BEGIN;
INSERT INTO `sp_store_goods_stock` VALUES (1, 1, 1500, NULL, NULL, '2023-08-31 17:23:18');
INSERT INTO `sp_store_goods_stock` VALUES (1, 3, 5180, NULL, 10, '2023-08-18 00:10:15');
INSERT INTO `sp_store_goods_stock` VALUES (2, 1, 3000, NULL, 10, '2023-08-31 17:23:18');
INSERT INTO `sp_store_goods_stock` VALUES (3, 1, 1900, NULL, 12, '2023-08-17 19:45:41');
INSERT INTO `sp_store_goods_stock` VALUES (4, 1, 600, NULL, NULL, '2023-08-31 17:23:02');
INSERT INTO `sp_store_goods_stock` VALUES (79, 1, 40, NULL, NULL, '2023-08-31 17:23:02');
COMMIT;

-- ----------------------------
-- Table structure for sp_store_house
-- ----------------------------
DROP TABLE IF EXISTS `sp_store_house`;
CREATE TABLE `sp_store_house` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '仓库id',
  `store_id` bigint(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  `store_house_name` varchar(200) NOT NULL DEFAULT '' COMMENT '仓库名称',
  `area_address` varchar(1000) NOT NULL DEFAULT '' COMMENT '详情地址',
  `is_show` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`,`store_house_name`),
  UNIQUE KEY `store_house_name` (`store_id`,`store_house_name`) COMMENT '仓库'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='仓库表';

-- ----------------------------
-- Records of sp_store_house
-- ----------------------------
BEGIN;
INSERT INTO `sp_store_house` VALUES (1, 5, '门店', '广州天健广场', 1, '2023-02-26 19:55:32', '2023-08-23 22:02:27');
INSERT INTO `sp_store_house` VALUES (2, 6, '门店', '东莞寮步', 1, '2023-02-26 19:57:14', '2023-08-23 22:02:30');
INSERT INTO `sp_store_house` VALUES (3, 5, '海虹', '海虹1号', 1, '2023-06-01 16:55:44', '2023-06-01 16:55:44');
INSERT INTO `sp_store_house` VALUES (4, 7, '门店', '珠海坦洲', 1, '2023-06-01 20:50:20', '2023-06-01 20:50:20');
COMMIT;

-- ----------------------------
-- Table structure for sp_store_order
-- ----------------------------
DROP TABLE IF EXISTS `sp_store_order`;
CREATE TABLE `sp_store_order` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增序号',
  `related_no` bigint(20) DEFAULT NULL COMMENT '关联订单id',
  `order_no` bigint(20) NOT NULL COMMENT '订单号',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `customer_id` bigint(20) NOT NULL COMMENT '客户id',
  `goods_info` varchar(1000) DEFAULT NULL COMMENT '商品信息',
  `status` varchar(2) NOT NULL COMMENT '状态：1:未发货 2:已发货 3: 已收货 4: 已退货 5: 已完成 6: 已评价 7: 已取消 8: 已删除',
  `price` decimal(8,2) unsigned DEFAULT NULL,
  `pay_price` decimal(8,2) unsigned DEFAULT NULL COMMENT '支付金额',
  `discount` decimal(8,2) NOT NULL DEFAULT '1.00' COMMENT '折扣 ',
  `decrease` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '优惠',
  `order_type` int(11) NOT NULL COMMENT '类型：1: 采购入库，2: 销售出库，3: 同价调拨， 4: 其他入库，5: 采购退货，6: 报溢单，7: 报损单，8: 其他出库',
  `company_name` varchar(100) NOT NULL DEFAULT '' COMMENT '单位名称',
  `sub_company_name` varchar(100) NOT NULL DEFAULT '' COMMENT '单位名称—简称',
  `customer_name` varchar(100) NOT NULL DEFAULT '' COMMENT '联系人',
  `phone` varchar(255) NOT NULL DEFAULT '' COMMENT '移动电话',
  `tel_phone` varchar(255) NOT NULL DEFAULT '' COMMENT '固定电话',
  `area` varchar(255) NOT NULL DEFAULT '' COMMENT '区域： 取字典值 customer_area',
  `area_address` varchar(255) NOT NULL DEFAULT '' COMMENT '详细地址',
  `company_type` varchar(100) NOT NULL DEFAULT '' COMMENT '单位类型：取字典值 company_type',
  `customer_type` varchar(100) NOT NULL DEFAULT '' COMMENT '类型：取字典值 customer_type',
  `bank_name` varchar(100) NOT NULL DEFAULT '' COMMENT '开户行',
  `bank` varchar(100) NOT NULL DEFAULT '' COMMENT '银行帐号',
  `remarks` text COMMENT '备注',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `coupon_price` decimal(8,2) DEFAULT NULL COMMENT '优惠金额',
  `freight_price` decimal(8,2) DEFAULT NULL COMMENT '运费',
  `total_price` decimal(8,2) DEFAULT NULL COMMENT '总金额',
  `total_num` int(11) DEFAULT NULL COMMENT '数量',
  `pay_status` int(2) DEFAULT NULL COMMENT '支付状态',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `is_delete` int(2) DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT='订单表';

-- ----------------------------
-- Records of sp_store_order
-- ----------------------------
BEGIN;
INSERT INTO `sp_store_order` VALUES (31, NULL, 202308160010013, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-16 18:44:08', '2023-08-16 18:44:08', 0.00, 0.00, 220.00, 20, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (32, NULL, 202308160010014, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-16 18:46:39', '2023-08-16 18:46:39', 0.00, 0.00, 220.00, 20, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (33, NULL, 202308160010003, 5, 1, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '客户单位1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-16 22:23:22', '2023-08-16 22:23:22', 0.00, 0.00, 144.00, 12, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (34, NULL, 202308160010004, 5, 1, NULL, '1', NULL, NULL, 1.00, 0.00, 2, '客户单位1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-16 22:26:05', '2023-08-16 22:26:05', 0.00, 0.00, 390.00, 30, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (37, NULL, 202308160010007, 5, 1, NULL, '1', NULL, NULL, 1.00, 0.00, 2, '客户单位1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-16 22:32:25', '2023-08-16 22:32:25', 0.00, 0.00, 390.00, 30, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (38, NULL, 202308170010001, 5, 1, NULL, '1', NULL, NULL, 1.00, 0.00, 2, '客户单位1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-17 15:03:59', '2023-08-17 15:03:59', 0.00, 0.00, 2200.01, 220, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (39, NULL, 202308170010002, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-17 19:40:30', '2023-08-17 20:03:16', 0.00, 0.00, 64000.00, 6000, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (40, NULL, 202308170010003, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-17 19:53:05', '2023-08-17 20:20:05', 0.00, 0.00, 3000.00, 300, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (41, NULL, 202308170010004, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-17 20:11:52', '2023-08-17 20:20:06', 0.00, 0.00, 900.00, 100, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (42, NULL, 202308170010005, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-17 20:23:46', '2023-08-17 20:23:46', 0.00, 0.00, 3000.00, 300, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (43, NULL, 202308170010006, 5, 3, '', '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-17 20:28:00', '2023-08-18 00:03:12', 0.00, 0.00, 10000.00, 1020, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (44, NULL, 202308170010007, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-17 22:28:39', '2023-08-17 22:41:58', 0.00, 0.00, 900.00, 100, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (45, NULL, 202308270010001, 5, 3, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '供应商1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-27 14:46:37', '2023-08-27 14:46:37', 0.00, 0.00, 2800.00, 300, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (46, NULL, 202308310010001, 5, 1, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '客户单位1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-31 08:00:00', '2023-08-31 15:51:49', 0.00, 0.00, 4800.00, 600, 0, NULL, 0);
INSERT INTO `sp_store_order` VALUES (47, NULL, 202308310010002, 5, 1, NULL, '1', NULL, NULL, 1.00, 0.00, 1, '客户单位1', '', '', '', '', '', '', '', '', '', '', '', '2023-08-31 08:00:00', '2023-08-31 17:23:02', 0.00, 0.00, 8400.00, 1200, 0, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sp_store_order_goods
-- ----------------------------
DROP TABLE IF EXISTS `sp_store_order_goods`;
CREATE TABLE `sp_store_order_goods` (
  `order_id` bigint(20) NOT NULL,
  `sku_id` bigint(10) unsigned NOT NULL COMMENT '商品ID',
  `goods_name` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '商品名称',
  `sku` varchar(128) NOT NULL COMMENT '商品属性索引值 (attr_value|attr_value[|....])',
  `store_house_id` bigint(20) NOT NULL COMMENT '仓库id',
  `goods_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '数量sales',
  `goods_price` decimal(8,2) unsigned NOT NULL COMMENT '金额',
  `discount` decimal(8,2) NOT NULL DEFAULT '1.00' COMMENT '折扣 ',
  `discount_price` decimal(8,2) unsigned NOT NULL COMMENT '折后金额',
  `order_type` varchar(2) NOT NULL COMMENT '类型：1: 入库， 2出库',
  `remarks` text COMMENT '备注',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`order_id`,`sku_id`,`goods_price`) USING BTREE,
  UNIQUE KEY `sku_id` (`order_id`,`sku_id`,`goods_price`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单详情';

-- ----------------------------
-- Records of sp_store_order_goods
-- ----------------------------
BEGIN;
INSERT INTO `sp_store_order_goods` VALUES (31, 57, '捷时达666', '白色', 1, 20, 11.00, 1.00, 11.00, '1', '', '2023-08-16 18:44:08', '2023-11-01 16:29:09');
INSERT INTO `sp_store_order_goods` VALUES (32, 57, '捷时达666', '白色', 1, 20, 11.00, 1.00, 11.00, '1', '', '2023-08-16 18:46:39', '2023-11-01 16:03:50');
INSERT INTO `sp_store_order_goods` VALUES (33, 2, '捷时达995', '白色', 1, 12, 12.00, 1.00, 12.00, '1', '', '2023-08-16 22:23:22', '2023-11-01 16:29:09');
INSERT INTO `sp_store_order_goods` VALUES (34, 2, '捷时达995', '白色', 1, 30, 13.00, 1.00, 13.00, '1', '', '2023-08-16 22:26:05', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (37, 2, '捷时达995', '白色', 1, 30, 13.00, 1.00, 13.00, '2', '', '2023-08-16 22:32:25', '2023-11-01 16:06:44');
INSERT INTO `sp_store_order_goods` VALUES (38, 2, '捷时达995', '白色', 1, 20, 0.00, 1.00, 0.01, '2', '', '2023-08-17 15:03:59', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (38, 2, '捷时达995', '白色', 1, 100, 10.00, 1.00, 10.00, '2', '', '2023-08-17 15:03:59', '2023-11-01 16:02:47');
INSERT INTO `sp_store_order_goods` VALUES (38, 3, '捷时达995', '透明', 1, 100, 12.00, 1.00, 12.00, '2', '', '2023-08-17 15:03:59', '2023-11-01 16:03:50');
INSERT INTO `sp_store_order_goods` VALUES (39, 1, '捷时达995', '灰色', 3, 2000, 10.00, 1.00, 10.00, '1', '', '2023-08-17 19:40:30', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (39, 2, '捷时达995', '白色', 3, 2000, 10.00, 1.00, 10.00, '1', '', '2023-08-17 19:40:30', '2023-11-01 16:03:50');
INSERT INTO `sp_store_order_goods` VALUES (39, 3, '捷时达995', '透明', 3, 2000, 12.00, 1.00, 12.00, '1', '', '2023-08-17 19:40:30', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (41, 1, '捷时达995', '灰色', 1, 100, 9.00, 1.00, 9.00, '1', '', '2023-08-17 20:11:52', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (43, 1, '捷时达995', '灰色', 3, 20, 0.00, 1.00, 0.01, '1', '', '2023-08-17 20:28:00', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (43, 1, '捷时达995', '灰色', 1, 1000, 10.00, 1.00, 10.00, '1', '', '2023-08-17 20:28:00', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (44, 1, '捷时达995', '灰色', 1, 100, 9.00, 1.00, 9.00, '1', '', '2023-08-17 22:28:40', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (45, 1, '捷时达995', '灰色', 1, 100, 10.00, 1.00, 10.00, '1', '', '2023-08-27 14:46:37', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (45, 2, '捷时达995', '白色', 1, 200, 9.00, 1.00, 9.00, '1', '', '2023-08-27 14:46:37', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (46, 1, '捷时达995', '灰色', 1, 200, 8.00, 1.00, 8.00, '1', '', '2023-08-31 15:51:49', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (46, 2, '捷时达995', '白色', 1, 400, 8.00, 1.00, 8.00, '1', '', '2023-08-31 15:51:49', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (47, 1, '捷时达995', '灰色', 1, 200, 7.00, 1.00, 7.00, '1', '', '2023-08-31 17:23:02', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (47, 2, '捷时达995', '白色', 1, 400, 7.00, 1.00, 7.00, '1', '', '2023-08-31 17:23:02', '2023-11-01 15:35:13');
INSERT INTO `sp_store_order_goods` VALUES (47, 4, '捷时达995', '黑色', 1, 600, 7.00, 1.00, 7.00, '1', '', '2023-08-31 17:23:02', '2023-11-01 15:35:13');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '字典id',
  `name` varchar(255) NOT NULL COMMENT '字典名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `store_id` int(11) DEFAULT NULL COMMENT '门店id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='数据字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES (140, 'order_status', '订单状态', '2023-02-27 17:40:42', 5);
INSERT INTO `sys_dict` VALUES (141, 'order_type', '订单类型', '2023-02-27 17:44:57', 5);
INSERT INTO `sys_dict` VALUES (142, 'company_type', '企业类型', '2023-02-27 18:13:47', 5);
INSERT INTO `sys_dict` VALUES (143, 'customer_type', '供销类型', '2023-02-27 18:21:32', 5);
INSERT INTO `sys_dict` VALUES (144, 'goods_attr', '商品属性', '2023-02-27 20:48:55', 5);
INSERT INTO `sys_dict` VALUES (145, 'goods_attr_color', '商品属性-颜色', '2023-03-01 13:53:05', 5);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_detail`;
CREATE TABLE `sys_dict_detail` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `label` varchar(255) NOT NULL COMMENT '字典标签',
  `value` varchar(255) NOT NULL COMMENT '字典值',
  `sort` int(11) NOT NULL DEFAULT '500' COMMENT '排序',
  `dict_id` bigint(11) NOT NULL COMMENT '字典id',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `dict_id` (`dict_id`),
  CONSTRAINT `sys_dict_detail_ibfk_1` FOREIGN KEY (`dict_id`) REFERENCES `sys_dict` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=419 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='数据字典详情';

-- ----------------------------
-- Records of sys_dict_detail
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_detail` VALUES (390, '未发货', '1', 500, 140, '2023-02-27 17:41:11');
INSERT INTO `sys_dict_detail` VALUES (391, '已发货', '2', 500, 140, '2023-02-27 17:41:19');
INSERT INTO `sys_dict_detail` VALUES (392, '已完成', '3', 500, 140, '2023-02-27 17:43:54');
INSERT INTO `sys_dict_detail` VALUES (393, '已取消', '4', 500, 140, '2023-02-27 17:44:06');
INSERT INTO `sys_dict_detail` VALUES (394, '已删除', '5', 500, 140, '2023-02-27 17:44:19');
INSERT INTO `sys_dict_detail` VALUES (395, '采购入库', '1', 500, 141, '2023-02-27 17:54:36');
INSERT INTO `sys_dict_detail` VALUES (396, '销售出库', '2', 500, 141, '2023-02-27 17:55:15');
INSERT INTO `sys_dict_detail` VALUES (397, '同价调拨', '3', 500, 141, '2023-02-27 17:55:26');
INSERT INTO `sys_dict_detail` VALUES (398, '其他入库', '4', 500, 141, '2023-02-27 17:55:39');
INSERT INTO `sys_dict_detail` VALUES (399, '采购退货', '5', 500, 141, '2023-02-27 17:55:56');
INSERT INTO `sys_dict_detail` VALUES (400, '报溢单', '6', 500, 141, '2023-02-27 17:57:59');
INSERT INTO `sys_dict_detail` VALUES (401, '报损单', '7', 500, 141, '2023-02-27 17:58:07');
INSERT INTO `sys_dict_detail` VALUES (402, '其他出库', '8', 500, 141, '2023-02-27 17:58:15');
INSERT INTO `sys_dict_detail` VALUES (403, '商品生产企业', '1', 500, 142, '2023-02-27 18:20:28');
INSERT INTO `sys_dict_detail` VALUES (404, '商品代理经销商', '2', 500, 142, '2023-02-27 18:20:52');
INSERT INTO `sys_dict_detail` VALUES (405, '供应商', '1', 500, 143, '2023-02-27 18:21:51');
INSERT INTO `sys_dict_detail` VALUES (406, '经销商', '2', 500, 143, '2023-02-27 18:22:05');
INSERT INTO `sys_dict_detail` VALUES (407, '供销皆是', '3', 500, 143, '2023-02-27 18:22:16');
INSERT INTO `sys_dict_detail` VALUES (412, '颜色', 'goods_attr_color', 500, 144, '2023-02-28 20:34:39');
INSERT INTO `sys_dict_detail` VALUES (413, '透明', '1', 500, 145, '2023-03-01 13:53:17');
INSERT INTO `sys_dict_detail` VALUES (414, '黑色', '2', 500, 145, '2023-03-01 13:53:23');
INSERT INTO `sys_dict_detail` VALUES (415, '白色', '3', 500, 145, '2023-03-01 13:53:30');
INSERT INTO `sys_dict_detail` VALUES (416, '灰色', '4', 500, 145, '2023-03-01 13:53:37');
INSERT INTO `sys_dict_detail` VALUES (417, '重量', 'goods_attr_volume_g', 500, 144, '2023-03-01 16:51:33');
INSERT INTO `sys_dict_detail` VALUES (418, '容量', 'goods_attr_volume_ml', 500, 144, '2023-03-01 16:52:04');
COMMIT;

-- ----------------------------
-- Table structure for tokens
-- ----------------------------
DROP TABLE IF EXISTS `tokens`;
CREATE TABLE `tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `userId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tokens
-- ----------------------------
BEGIN;
INSERT INTO `tokens` VALUES (14, '2020-02-21 03:39:33', '2020-02-21 03:39:33', 6);
INSERT INTO `tokens` VALUES (18, '2020-02-21 14:20:08', '2020-02-21 14:20:08', 6);
INSERT INTO `tokens` VALUES (19, '2020-02-21 15:11:56', '2020-02-21 15:11:56', 7);
INSERT INTO `tokens` VALUES (21, '2020-02-22 14:44:33', '2020-02-22 14:44:33', 6);
INSERT INTO `tokens` VALUES (24, '2020-02-24 11:49:11', '2020-02-24 11:49:11', 5);
INSERT INTO `tokens` VALUES (28, '2020-02-24 13:17:01', '2020-02-24 13:17:01', 10);
INSERT INTO `tokens` VALUES (32, '2020-02-24 14:06:02', '2020-02-24 14:06:02', 11);
INSERT INTO `tokens` VALUES (37, '2020-02-24 14:36:36', '2020-02-24 14:36:36', 11);
INSERT INTO `tokens` VALUES (40, '2020-02-25 11:39:50', '2020-02-25 11:39:50', 4);
INSERT INTO `tokens` VALUES (41, '2020-02-25 11:40:01', '2020-02-25 11:40:01', 1);
INSERT INTO `tokens` VALUES (44, '2023-02-26 14:09:37', '2023-02-26 14:09:37', 1);
INSERT INTO `tokens` VALUES (49, '2023-02-26 14:12:28', '2023-02-26 14:12:28', 2);
INSERT INTO `tokens` VALUES (50, '2023-02-26 14:12:41', '2023-02-26 14:12:41', 1);
INSERT INTO `tokens` VALUES (52, '2023-02-26 14:18:11', '2023-02-26 14:18:11', 2);
INSERT INTO `tokens` VALUES (54, '2023-02-26 15:26:22', '2023-02-26 15:26:22', 2);
INSERT INTO `tokens` VALUES (128, '2023-11-26 17:15:47', '2023-11-26 17:15:47', 12);
INSERT INTO `tokens` VALUES (129, '2023-11-26 17:17:31', '2023-11-26 17:17:31', 12);
INSERT INTO `tokens` VALUES (132, '2023-11-26 17:26:02', '2023-11-26 17:26:02', 12);
INSERT INTO `tokens` VALUES (134, '2023-11-30 19:08:13', '2023-11-30 19:08:13', 3);
INSERT INTO `tokens` VALUES (135, '2024-01-11 17:25:50', '2024-01-11 17:25:50', 3);
INSERT INTO `tokens` VALUES (136, '2024-01-11 17:30:01', '2024-01-11 17:30:01', 3);
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(255) DEFAULT 'student',
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `checkTime` datetime DEFAULT NULL COMMENT '入住宿舍时间',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `roomId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`account`),
  KEY `roomId` (`roomId`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`roomId`) REFERENCES `rooms` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (1, '123456', '$2a$10$vGnvYKcAYAOLwLF7blj2JeyORsf/BDb/5qVsIoC6ohuD0.4zln7P6', 'student', '王麻', '12222222222', '2020-02-15 14:57:14', '2020-02-15 14:34:55', '2020-02-25 11:40:09', NULL, 1);
INSERT INTO `users` VALUES (2, 'admin', '$2a$10$NNZoAxHHO.NJq1AJLzp.4eRBMCRWfJbiPltpJdV3yNV4iP2cASB.K', 'admin', '王晓鹏', '1233333', NULL, '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, NULL);
INSERT INTO `users` VALUES (3, 'superAdmin', '$2a$10$UzYrrpiCanig0CFGdqONRe.c65B9d9sEOiD1wH6B/oZCXubJKLi6m', 'superAdmin', '李达康', '122222222', NULL, '2020-02-15 14:34:55', '2020-02-24 14:24:53', NULL, NULL);
INSERT INTO `users` VALUES (4, '111111', '$2a$10$Zm41SRjOlSYl2ph3.YwL/.X340x5PBdr46MOOeKDJjblHBbAYqEl2', 'student', '哇水水', '123456789011', '2020-02-15 14:34:55', '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, 1);
INSERT INTO `users` VALUES (5, '222222', '$2a$10$JAeYA769PDtIL6oqHvv7TOTaFOJZGK7iOwXsxJiMxcZb/VYNXbtrK', 'student', '王大拿', '123456789011', '2020-02-15 14:34:55', '2020-02-15 14:34:55', '2020-02-15 14:34:55', NULL, 1);
INSERT INTO `users` VALUES (6, '333333', '$2a$10$IvA0ATl.h2NwRS4XFrcsxuF2eEagmwRGGieAYiAdCTA5tEz714H9W', 'student', '王彪s', '1222322333', '2020-02-21 04:49:51', '2020-02-20 07:03:17', '2020-02-21 09:02:34', NULL, 2);
INSERT INTO `users` VALUES (7, '666666', '$2a$10$h8yVZoEnfOy/DnBnOq4aEOgoS1Zm81b722bV7Na.u0.xBxgzhpURC', 'student', '测试员', '1233333333333', '2020-02-21 15:12:16', '2020-02-21 15:11:55', '2020-02-21 15:12:16', NULL, 2);
INSERT INTO `users` VALUES (11, '10101010', '$2a$10$urcAJNlkFOpwlJIhPV1l/egzU0uH8eGs8AxgjR5f9JAE6hR7xj7rW', 'student', '测试', '123456', '2020-02-24 14:07:27', '2020-02-24 14:05:57', '2020-02-24 14:10:00', NULL, 1);
INSERT INTO `users` VALUES (12, 'admin2', '$2a$10$UzYrrpiCanig0CFGdqONRe.c65B9d9sEOiD1wH6B/oZCXubJKLi6m', 'admin', 'admin2', '123', NULL, '2020-02-24 14:21:48', '2020-02-24 14:21:48', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
